Calculate the mean per time slot ?

Question

Level 1

5 points

Calculate the mean per time slot ?

Hi Chaps,

I'm an absolute beginner on Numbers (almost everything on Mac i would say) and i need help to calculate mean values.

Those are calculated values (Column 2) taken on a precise moment of the day (Column 1).
I managed to create a third using an integrated function to get the time slot (Column 3).

14:58:42	235	14
14:59:42	274	14
15:00:50	7937	15
15:01:55	5157	15
16:02:57	1822	16
16:03:57	207	16

Can please someone show me step by step how to calculate the mean value per time slot like below?

14	254,5
15	6547
16	1014,5

Regards,

Pierre

Posted on Sep 17, 2016 10:11 AM

Reply

Answer 1

Sep 17, 2016 11:07 AM in response to dragandpaste

This may help you

assuming you data is in a table named "Data" and the information is summarized in another table (on the right) named "Summary"

select cell B1 of the summary table then type (or copy and paste from here):

=SUMIF(Data::C,A1,Data::B)÷COUNTIF(Data::C,A1)

shorthand for this is:

B1=SUMIF(Data::C,A1,Data::B)÷COUNTIF(Data::C,A1)

select cell B1, copy

select column B, paste

Reply

Answer 2

dragandpaste Author

Level 1

5 points

Sep 17, 2016 11:08 AM in response to Wayne Contello

Thanks a ton Wayne. It works !

Reply